SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280401 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280401 [ RunTime:0.002391s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515354,883673,218339,57437,658421,43809,798968,573975,879926,599358,713292,270739,79861,874896,691134,847955,759439,502696,464558,121231,468852,926826,653344,293741,1017744,252242,139748,432372,444746,758269,194907,701002,578623,785315,106945,417950,989225,911914,190558,158351,896008,136866,1018727,847060,367908,816504,807692,85588,702104,794578,629487,726882,1036374,160284,255466,1010601,994946,369641,479475,62297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]