SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001737s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102978 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102978 [ RunTime:0.002975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431394,584127,157040,636251,996720,742947,47612,514103,593582,1010366,236164,144811,29573,897219,460593,722444,680758,537019,829396,383877,961728,119909,329265,515411,583504,532393,286020,753151,607343,108744,277815,138734,558692,734863,237395,304763,358015,942965,176429,380147,910662,548193,932202,874236,15300,967563,680171,995283,883930,163857,431320,896822,438720,239208,76240,755740,770723,344642,640593,842263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001208s ]