SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511041 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511041 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435284,768331,999861,821583,45412,343854,799739,343157,385206,562619,848239,488226,957114,936843,975838,400977,431311,898190,243052,656336,676738,338989,1030345,268567,61574,827234,54791,859303,1006798,841388,670403,390201,783093,14289,207164,762716,984150,795411,1001228,123648,760262,295237,697547,525649,465698,287499,203426,100403,8858,310371,335608,759496,486848,454473,193360,874000,47056,984219,622286,677178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]