SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564218 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564218 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (589032,450391,329426,908287,404585,1021291,526709,605022,989918,821441,600773,948131,599344,262203,735807,818731,597239,762726,180995,748862,938419,840970,577778,1006859,324191,475113,908347,947668,876494,335849,966456,245995,692420,958507,226341,258320,928940,565768,569195,906515,264254,1002148,716654,315134,128039,446897,760918,569527,668235,265041,180625,1041629,792487,209623,728975,97513,297707,303779,319634,339299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]