SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269864 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269864 [ RunTime:0.003509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910679,470751,159480,990970,142676,163206,842161,114402,932499,27922,362378,564017,598975,22531,71274,879714,811379,780000,154485,1043317,436757,422251,36410,118616,979037,936775,356371,317294,675663,233432,533430,704616,17420,511567,245360,765591,752692,866560,855909,631942,936864,41795,832207,714242,29369,271368,266368,191792,894286,447024,101676,479443,870998,810410,239678,271868,565615,92498,354893,26081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001168s ]