SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482847 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482847 [ RunTime:0.002024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005782,144065,497606,172493,326474,784271,378360,478874,41062,1045230,1033383,599100,1025832,792676,510065,303684,742649,27300,906407,1034773,1007850,692379,115180,900704,4471,13815,40782,352479,684849,868375,348239,73507,399516,134229,774819,387529,339272,934888,989732,995621,892534,165157,753834,984747,100595,45452,11947,452553,375895,450659,641514,28000,1030963,94339,632829,1011608,911859,169414,268932,60495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]