SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264809 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264809 [ RunTime:0.002523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017815,967169,308613,372205,1032456,253292,14293,723818,547390,496631,761386,807225,210899,179105,485116,246509,437818,806017,886956,18472,506759,512675,725400,877596,652646,534477,227968,166545,174941,170319,977379,15777,141836,68830,84415,1023723,338478,271517,604768,414620,781036,937826,908347,265502,1004349,2306,29833,48813,972992,700979,269294,370647,507248,350189,837867,1043800,184728,703301,430998,1017744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]