SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043311 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043311 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350406,23818,723498,446072,230407,626858,797529,917199,855224,822568,878554,212445,1029107,82328,40752,730889,622295,945779,740010,634494,559901,419017,1003348,676988,686925,796785,838905,988205,338898,495554,537951,355542,101730,564293,737673,368082,33438,134533,500540,696895,168453,112127,589429,598240,981842,115329,495359,216413,853031,955882,798678,243589,379907,626909,804506,659673,674940,714797,861374,50085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000711s ]