SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356407 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356407 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698049,43900,413584,225893,918037,1018339,111517,717141,749490,575228,932987,175095,754236,22765,860602,815728,943211,311397,392220,167777,459115,268622,554305,579568,92397,598906,956478,368725,223497,897106,287390,1037891,299361,437242,248956,970066,353513,843321,664806,780012,374775,648447,933614,434983,24452,122829,27346,168297,62091,719918,879787,223341,602504,333788,726152,15849,994659,855888,372821,636543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]