SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563831 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563831 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763563,642501,133254,541714,125944,257378,5017,9805,419110,313746,287094,607294,475026,492461,634435,518943,506594,1021795,728557,19798,1016540,56030,748369,616292,710970,638407,904774,331326,633629,804198,934424,826926,203653,952542,7505,66104,113081,485190,1036287,498143,758590,739297,261964,112765,740317,196482,407608,782424,903186,763213,658349,893242,722270,296941,372991,17188,914630,750915,863718,971538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]