SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31581 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31581 [ RunTime:0.004358s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750087,336257,1002299,1012841,111048,810439,307304,888309,49608,896873,156513,14572,1018320,75931,170661,823201,406281,933330,340368,841522,313309,306310,126358,248450,171541,179167,502172,751924,1022566,36176,805247,74175,961540,855579,635497,969940,223834,438137,1015278,774633,700867,541888,200193,537255,568838,912869,508816,407220,8535,266270,404861,987623,916479,17402,414595,619625,406480,204550,457238,265719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]