SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499940 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499940 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774534,850244,843195,55395,880005,926482,391751,104228,207783,2999,685047,778023,344212,643055,811264,59901,789639,513778,450819,413527,927028,335129,567979,242146,463799,868552,553449,618328,553346,910298,155311,584188,115295,586857,283667,1046787,326877,644340,951639,520107,325106,118120,633254,917542,428423,135356,1047601,888685,291141,748482,232487,933629,258156,107197,691911,248274,951018,149302,125684,414092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]