SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454851 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454851 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804118,135821,185731,349115,393232,47741,835245,367275,835745,279463,874326,872619,894056,401459,573991,345235,672488,267757,740852,355013,938059,308151,230271,924849,1027004,99458,799252,337456,19663,978496,179854,905533,130739,954872,538250,58226,30545,283073,359342,948826,494965,663790,902728,249834,308750,364844,911720,558589,322734,374370,206522,608052,79245,325872,500018,89108,74423,729196,58716,1003604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]