SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002652s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545015 LIMIT 1 [ RunTime:0.000589s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545015 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006230,1047445,29230,541188,878971,606844,905090,54010,909169,757583,1047406,936654,579044,696147,634260,1043796,599474,572101,893320,833967,1001158,945844,394142,459153,400122,703513,849843,195157,889879,836414,185226,433131,855612,2598,85935,533159,6687,896198,1022995,751145,477267,938807,862095,10189,620188,1042274,738455,99805,696896,654786,1019905,677939,634986,917101,250072,85159,1012320,286937,569406,483270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]