SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 638343 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 638343 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011431,4964,562002,347855,612995,59528,606183,969204,681649,716301,535956,126660,535581,750726,623697,77935,437753,473846,738279,459743,302704,217017,947441,807852,349990,1015467,775289,995822,971234,590186,593397,304733,1036918,777856,464256,276026,268294,415233,929701,486104,129106,782270,228155,741444,776378,259560,43579,400950,38578,517046,499473,324017,632270,617529,205914,735213,1042058,522317,504780,99828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 638343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 638343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000822s ]