SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456217 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456217 [ RunTime:0.001469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305082,841501,34986,383905,41623,964000,119108,671670,872475,689137,40015,13394,97651,78651,164785,448038,567838,636797,457755,649140,194576,598334,146913,568163,435908,347418,770092,760073,880713,404285,603053,304034,444937,713031,531917,826048,379577,538199,318402,562524,981840,1006494,342681,34609,121692,146906,307619,415046,953002,26232,918042,498159,174892,255134,563067,145252,593552,194253,119277,812389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]