SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984099 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984099 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561513,881733,830321,881269,780538,5856,798390,197434,109420,344300,949890,866722,591960,175680,1027976,580446,304921,815915,684916,431502,127863,735924,725286,330594,641775,63914,1005918,12433,906654,790237,168258,477403,907553,652205,373184,140169,222031,1046771,491449,50599,764613,316139,976718,422863,6829,267028,199126,235384,965711,346341,418295,563934,590391,289036,905795,245635,310749,788991,302958,314189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000865s ]