SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840454 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840454 [ RunTime:0.003347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684382,497056,313687,1019176,681795,22202,363881,354445,497737,455600,940806,782215,736789,753253,895673,139589,322360,86979,686352,83878,26840,43808,96144,1028948,642938,333806,556726,129562,470757,898435,982717,586024,109015,111529,200341,578295,700415,854992,703431,1047699,772885,659327,584800,1020277,743278,62986,459215,49412,141831,851581,1005907,905209,217642,770076,285586,414651,59458,557843,799796,791094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004175s ]