SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 141998 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141998 [ RunTime:0.004351s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532342,608163,499353,103708,569123,782225,635789,710806,869681,834572,776251,664050,238754,665797,201993,802287,532983,712307,958001,769547,551779,500130,109670,898905,294020,1013347,726752,813164,31090,402273,965389,791721,920199,599893,321561,1047345,735957,509438,947623,998119,230282,816848,133356,627934,5665,412964,415698,12869,909572,851172,1017207,681572,807101,343279,991167,374375,1019483,821589,597115,450158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]