SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002517s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38230 LIMIT 1 [ RunTime:0.000579s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38230 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86628,911103,166983,353849,554574,974805,122923,148545,147938,895145,143035,389962,28512,34142,572688,214372,456720,104838,612499,922829,95998,606635,247086,352535,598403,892660,812226,248506,160569,398200,460608,343386,776576,1043170,425708,567829,778093,729266,959243,361807,1029570,587094,366716,174865,487583,749789,946381,472661,993235,565880,76643,864131,239784,734291,936301,728049,757574,79327,633356,444133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]