SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398299 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398299 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502727,216288,348755,523497,543163,540871,860935,670536,68120,39862,305450,913467,394217,713980,347364,143303,494091,1019216,1005585,999487,512520,69595,254014,752641,433050,852887,749794,840820,1003445,846245,716824,341568,1019435,1022994,826776,735182,1009616,543425,505008,148517,51908,826980,138896,733546,960965,1008064,195567,807839,219767,496702,603845,955236,343041,964355,755525,402549,939372,910598,347516,212759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004076s ]