SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 147817 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 147817 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118541,139885,784519,830001,216571,332906,152273,194126,939174,890674,600210,529083,856591,1032722,311962,500538,110211,744695,861584,738112,513798,379602,928109,37197,115708,121933,871878,200904,868791,543511,158599,94823,305211,166161,553575,487068,950177,382177,943340,754830,455117,878339,10838,322938,448393,222130,311200,491241,816127,227192,886698,167235,592958,728458,996206,897250,118417,903753,772507,954193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 147817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 147817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]