SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 941453 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 941453 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (985900,397572,261581,393440,320573,703304,90233,539884,407680,514678,725593,371210,895387,820275,149776,517010,502363,64790,43027,772535,1034285,133792,542279,530624,67927,695435,862675,116052,848109,573957,179035,1032950,304869,303114,770707,921111,387523,699650,274504,734481,957925,740257,887524,614765,609490,206281,538647,296185,515989,104017,176036,465487,160201,520986,329831,1000581,285406,379748,930653,826141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 941453 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 941453 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003909s ]