SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438599 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438599 [ RunTime:0.002378s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67300,567153,308991,1007820,477526,866260,750979,627097,776,650846,262421,889983,36209,790988,803269,275886,593310,390306,1047581,776960,3919,375894,767209,811464,263708,691230,445431,883696,173202,603877,219462,318870,518320,231585,213015,120874,706945,352989,951264,790065,134246,879589,427742,6855,143912,519410,936326,904218,643044,351924,641418,90764,683160,114106,868176,573266,859371,734977,283061,477726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]