SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001580s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105327 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105327 [ RunTime:0.003087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860101,25777,342839,145290,145759,606738,339565,92702,33118,475337,241768,160232,910815,22037,459203,386504,538002,486954,734912,258065,438772,154330,773217,800132,367506,372935,357202,533714,991408,199090,112610,554615,51683,820800,964824,139322,14078,484889,1005200,842945,932833,472965,743317,469577,43847,381604,218825,786717,1045114,92734,341262,918099,387463,738888,1002738,2012,409667,291280,168784,416637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000754s ]