SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40136 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40136 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (726067,1014013,363069,594837,1027085,352401,882603,829218,436365,870800,926576,503611,24228,178406,399291,956087,702845,319202,343838,599148,35382,485428,570713,558679,345759,1023447,438873,418141,29973,118135,541051,636913,251910,631868,620975,989254,352723,362411,900748,899650,90127,893558,152818,1019176,240617,131672,37755,548167,130585,154022,284860,4350,445119,760897,696554,137065,61453,900524,1019166,265283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40136 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40136 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001997s ]