SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511217 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511217 [ RunTime:0.001470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282525,51029,702684,656149,484371,460389,925914,268492,777355,92583,347637,252082,76163,969216,841514,652363,1031052,931288,191117,26479,715090,807373,276101,167002,1025655,180120,800755,315075,729221,827967,304051,565095,751337,709617,19715,381692,2536,215164,932321,627622,553196,688016,850146,111496,1028538,14959,707681,391857,941600,486935,632496,163425,84144,366221,437660,267981,806610,911249,801557,830308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]