SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019351 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019351 [ RunTime:0.002565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182102,431550,210365,872063,162721,405335,638051,116874,137473,269015,781201,175410,702753,548005,754777,379248,243224,878307,210905,814114,172311,506911,142995,616583,808750,4725,277591,702375,151930,496802,250414,765258,989818,676582,451675,679013,148421,741667,235907,35850,137906,837960,816349,141747,1016546,227718,917299,88240,478369,37133,76150,269054,335078,190178,984320,686869,568280,498504,887904,917713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019351 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019351 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]