SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004888s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490206 LIMIT 1 [ RunTime:0.000514s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490206 [ RunTime:0.002266s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774618,461227,227785,690,224201,272193,214929,184554,1038329,25026,167394,749546,383904,922530,956980,182237,1020256,373964,655548,560335,539566,243438,885025,891605,441075,479233,1027680,762432,49645,707840,239175,706244,143556,305603,304402,206038,498706,116544,470908,512862,585129,280467,417291,724242,979919,533784,218634,339026,383380,623230,958482,477307,993820,513105,776119,338001,842031,578741,458488,827759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]