SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038530 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038530 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428236,690180,414045,770170,825071,195470,850370,186874,703830,511907,250157,975764,165722,397909,764336,806963,1041584,197271,79106,925502,652482,852448,474264,801621,973118,132265,654867,341986,308753,232773,780000,317375,889019,312751,863671,672660,996654,152238,356205,291984,166513,755247,588525,1042918,352539,163927,437790,963283,964952,579516,33227,169136,421243,735567,224458,687674,345038,541798,316381,877102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]