SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509435 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509435 [ RunTime:0.001494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344923,498413,280092,933255,809082,225446,60693,369598,22021,33101,462699,865909,667549,387795,132608,77932,779973,764598,5520,88279,798913,135863,141157,114507,397429,568336,982034,548812,377180,902292,11684,522640,730905,629857,407703,311717,497207,187821,1033951,510382,896849,974248,121434,159710,426463,974297,386033,1714,675987,45275,1040470,868696,900140,152453,753491,55233,558567,99055,351929,649480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]