SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100156 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100156 [ RunTime:0.002120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018388,686790,517258,935012,703774,602781,968945,517421,916523,646436,306861,1016008,261758,460599,847611,1044335,557648,1011398,697459,816911,937435,265526,905911,1005850,1037002,229741,697140,205207,111900,368604,263759,31189,627282,549889,990882,485686,756255,131124,886458,424582,1013732,329316,93798,458988,107551,1032738,853013,445741,518641,570652,1037967,773445,185364,1002708,291926,927056,127712,273802,461765,527048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100156 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100156 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]