SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920413 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920413 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701384,757272,897125,292138,368685,617401,967531,682273,106541,539678,544943,780966,306759,327654,56078,155448,350787,56949,296020,860350,792395,860734,685011,122101,623074,367636,675643,481351,128157,434072,357115,891891,72164,251524,193298,270969,356817,500774,785589,559357,317275,255892,1006232,108039,88902,357068,280356,177807,167341,625134,649461,857787,34080,468150,80030,940298,671194,651151,353900,138316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]