SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 186880 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 186880 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210460,1044108,717189,437006,399597,457821,406584,452315,955586,873255,102028,505282,436478,1029301,296719,914032,63612,1032139,666757,126859,309712,745811,735228,889661,794314,311131,1008061,237540,838447,582406,409700,158190,455776,1045410,1034790,156602,426853,636492,475939,276698,2224,722567,422888,1006750,806321,765365,463685,819344,153327,285989,432572,863579,285780,664173,264072,785179,615948,158062,739346,187093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 186880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 186880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]