SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40671 LIMIT 1 [ RunTime:0.000617s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40671 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410213,269117,622465,177614,1011053,340547,293117,1004055,145851,717030,841066,780871,948729,407986,276258,919394,743859,99497,1001516,826983,742707,708420,252983,852745,539693,372961,876955,1041727,399190,907741,975630,890588,518132,320207,323614,745664,333629,296831,765956,432977,614420,756467,562212,385742,862526,135204,1008804,597493,664178,407316,207191,662439,95318,479423,267506,441110,111398,949871,892461,864773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]