SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002946s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809135 LIMIT 1 [ RunTime:0.002630s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809135 [ RunTime:0.002418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931262,558749,910339,865831,264424,82116,642545,597936,116202,478852,30109,1045379,767610,143095,198,813313,820383,725841,47501,614197,458273,704722,276031,356148,833939,4657,114185,315918,845940,262950,1033443,293030,538651,831951,65118,126069,956930,681374,317322,111419,121229,1043893,136977,239386,600306,190280,578391,102413,240261,137635,591863,782522,303846,773655,110674,1044588,856738,861459,867168,843184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809135 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809135 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]