SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105326 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105326 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (834292,619557,318662,481806,33670,1027795,245610,653040,994717,697148,699905,189635,272785,51212,240151,329499,294117,434649,177725,207177,533225,976012,628827,887384,969294,917719,393237,1039618,116648,257572,771033,225970,41460,960777,893409,173603,236162,482786,810951,561289,3202,846627,348539,542234,632968,469122,439234,802991,976368,771195,16215,840393,570231,862212,459593,1027529,279166,697959,416421,733444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105326 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000867s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105326 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]