SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007061s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411151 LIMIT 1 [ RunTime:0.000704s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411151 [ RunTime:0.002226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045663,713622,295294,676832,788319,319550,955184,764182,321022,995310,333436,312943,959021,279411,795877,906352,706858,406774,648397,27897,651472,142889,1800,1027947,829792,932140,535142,649600,1045011,337807,995436,186816,690005,523227,669161,152088,69353,443157,815691,114837,223913,628937,535674,874981,151579,229697,241784,752122,942251,367305,760765,569873,758730,908151,553106,847356,40198,559066,452593,488892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001416s ]