SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412968 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412968 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406578,892063,62572,687123,456170,483512,241393,26730,564344,317370,1003887,48811,198342,574237,237339,1019239,219819,578332,651415,371608,751380,713901,335099,723940,268518,369543,979580,864510,982085,36747,147775,168137,290544,1040990,65470,365804,1046685,675767,752328,850559,674137,826389,1003326,604760,758956,319964,853269,204321,473215,303022,433270,1014180,858644,126853,885293,984525,264299,168954,488256,267298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]