SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521099 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521099 [ RunTime:0.002342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237613,116724,541600,810261,620890,158132,962636,641246,634395,135925,702695,490202,50865,1028979,165057,7585,59708,575111,115653,211943,933857,775572,128125,467660,978474,261873,344221,1007435,391001,868948,860439,56103,303307,843006,95940,815962,431299,117982,544817,93371,1018982,933738,226501,450914,959881,10021,749492,447658,528305,855846,337572,874676,107344,705153,826204,692252,1036999,134420,74782,404960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]