SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467907 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467907 [ RunTime:0.001927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660739,289153,18591,485477,999479,1019708,831513,388002,371618,307380,604744,317961,140706,764232,881448,187879,509171,399559,670447,40640,17250,746352,374529,850078,530771,965806,327163,1015061,329065,95181,282570,488031,576238,397883,719166,520348,1020753,722209,977049,530337,906515,806894,548403,131531,656006,264339,977699,515247,106567,803062,387039,951372,706237,928266,842685,950896,1025205,41319,871349,21953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]