SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001484s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544058 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544058 [ RunTime:0.002350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006512,71707,871168,912638,373308,328314,54138,55816,696881,888102,181137,710098,201571,986454,566742,740518,779684,983745,928739,612787,482307,766517,573824,725528,133052,657101,470257,861099,171655,118857,895597,985027,956154,447073,371195,113215,350163,404667,352860,241303,1021259,778014,226341,270131,701024,902938,61508,201931,489507,1042463,1023710,33270,749438,28067,633148,302955,954335,434093,1031775,151898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]