SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479198 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479198 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489140,1041481,804553,514850,99646,1038918,926657,852616,838318,156461,849959,446080,947440,411913,621411,252970,4778,443317,558295,794209,298183,779243,590681,227990,193925,216193,999850,83311,230763,355093,100228,258190,777505,722932,3969,411684,500406,279859,261962,613436,784756,569923,400258,703575,554191,569557,115318,768368,863330,603441,84244,731210,730096,290984,565887,215410,878189,1024052,74237,605321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]