SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510732 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510732 [ RunTime:0.002477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43223,448332,672820,943181,882657,48762,406624,398648,280761,419199,785729,136454,454327,417452,764504,157404,804888,425443,208329,652489,302583,261300,507539,974459,998073,529843,833579,739492,920697,639630,915490,650601,527298,598212,872226,234292,709533,172807,770359,82567,70455,951953,746419,541500,334663,516650,91583,831086,282413,79698,31920,332983,532273,669623,806546,392489,625541,121997,887991,772946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510732 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510732 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]