SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526842 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526842 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628393,896597,980757,740094,787330,536484,76015,206501,884225,547326,371560,791171,272935,183906,835347,646185,892808,28978,779449,176007,1014196,218475,382998,206108,422391,310638,411489,334977,936922,220494,986932,537694,233073,1001160,308018,89813,516689,172999,821098,809400,835779,1030298,296477,866260,117186,843772,401133,776252,295077,551575,743552,441646,324918,976337,552721,765328,1030941,903398,487790,108153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]