SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001535s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537212 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537212 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853890,492060,132711,289355,771350,622539,199269,642865,933443,251863,947967,22890,876930,961038,299712,220584,583564,44517,122799,133181,53737,240505,652083,49324,35469,552983,928551,659542,214901,597783,709963,443239,73878,71926,154753,542995,1036381,55206,147189,398450,567727,1039862,661619,661468,848845,203068,653179,93103,253740,821989,672199,1017898,767882,193754,648798,449495,200491,584778,67340,365178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]