SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 359218 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 359218 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122313,440573,865878,529386,16372,520724,942992,475286,729708,605747,676259,381106,852052,866692,397794,50838,770986,1035806,144372,520171,929163,25536,482471,548588,198182,796959,295194,109584,73354,551079,296420,859713,642680,1011397,27645,575456,535281,258328,333292,649640,469134,453928,168185,16516,317092,67432,290404,720364,610359,651255,573751,386738,864281,499471,561163,564731,760934,477172,338413,927120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 359218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 359218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]