SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391976 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391976 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248410,200994,627545,283622,250655,184175,392779,632062,294946,506777,72088,1041738,420726,866636,312882,773719,494869,652597,601577,379774,39564,80561,93796,691750,121348,1009400,232796,545072,211270,718584,645920,582928,709800,599312,424814,875013,179404,213931,485268,416833,790197,49172,394068,281413,957217,930028,681089,851299,248630,48313,260084,121076,132379,221299,489754,904075,915132,386337,478232,189655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]