SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544013 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544013 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715025,103844,854757,788495,969362,337894,329828,769355,81059,100671,524834,482209,613588,1041352,183216,357671,431128,1029568,847107,17238,840299,450114,826563,462152,6050,724921,1046548,12953,993525,91906,827364,564788,775246,943240,654944,116150,922049,1006523,155466,946774,129184,822835,75191,183324,163508,608067,897868,479627,607509,1042781,889808,8772,625010,14467,898980,726288,326243,499188,485532,177808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001715s ]