SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36710 LIMIT 1 [ RunTime:0.001297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36710 [ RunTime:0.004847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264814,675903,121716,981823,77249,380817,669041,620568,146734,677621,529883,838553,722236,762962,609865,424718,882959,878292,371913,199654,813219,760017,1034298,22528,998872,627866,601981,486764,704882,130166,834458,285827,971115,15394,968132,931759,981689,322793,849781,138720,587658,175817,279082,749982,889676,71619,652879,475111,109879,198212,697501,409661,707650,233337,208975,192415,269492,1043095,520595,354925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001796s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]