SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293511 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293511 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298100,452190,870569,509322,359802,851363,719099,291049,38743,832768,612552,694922,934225,707906,171540,1019010,588102,780265,732940,622564,914652,866492,243525,245615,175970,999126,978828,307554,41714,745093,658184,23311,458908,874048,714070,907755,1008999,114645,311523,628184,818582,685491,894828,526841,595948,393736,481069,542822,516427,1035919,236725,906094,22055,223344,724083,464752,372632,213525,503825,760355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]