SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671083 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671083 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496602,622037,579340,938743,577951,1018923,368689,260828,459434,328958,704575,922000,847411,1000024,558855,58064,287886,633901,702407,361761,905411,416674,893374,873444,699839,588845,377353,219026,184439,595057,65238,380277,832627,642603,925972,992322,741006,669358,754881,184585,1000314,343273,400958,6862,130138,100469,774569,723286,907666,82378,1025599,957936,1026451,273913,180078,120886,791600,926750,697813,506684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]