SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 161012 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 161012 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384140,918974,357815,869053,211181,201910,484346,817374,689744,143017,669038,47599,86698,1037435,916570,310444,19323,562178,460690,833895,338854,422310,614171,310955,1000994,73999,577340,625492,754597,482626,113100,595234,47743,317378,925886,231922,136185,384383,387418,243372,156461,392903,274539,625082,768247,589346,876121,895293,642915,610257,990665,449337,526432,163487,957095,273358,828332,375206,791749,731348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 161012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 161012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]