SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003873s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 155063 LIMIT 1 [ RunTime:0.000824s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 155063 [ RunTime:0.002883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287746,383864,662026,278435,5368,739084,356120,812120,650687,160941,115301,1003308,941515,291608,121955,855278,406804,6170,690514,220282,874797,268358,27128,301847,447062,1048613,709496,252605,367239,738983,540153,394077,436858,36372,166650,1005634,961964,790497,569255,507944,829917,232602,660144,811111,984745,428259,311183,151195,144440,616336,803170,973371,125483,185513,436514,651731,235367,376461,357649,493398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 155063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 155063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000376s ]