SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042133 LIMIT 1 [ RunTime:0.000560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042133 [ RunTime:0.002237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021715,1041950,913936,39617,10348,533119,634402,725310,128698,949623,751861,534366,757731,223127,539597,854426,574284,852271,61833,403282,450737,57614,723967,355687,850339,154068,327514,369164,729820,392660,916727,880279,758133,308395,269766,116554,963109,462870,870231,1004172,432317,582329,965716,219301,722562,215317,159822,296877,796964,84269,388605,752996,659841,1032747,616425,1029300,955433,73455,804742,1009541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]