SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805070 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805070 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124027,386300,288571,420214,572043,248673,397147,278927,212590,17169,252482,227677,579305,220052,319451,578786,1036898,132599,505324,958279,102104,769777,482453,670632,424831,1041776,218802,978623,402729,50799,51037,2090,579209,201882,322566,788064,648739,152262,100852,710499,626564,507727,297849,141149,534952,842021,828724,676938,453108,1003819,543407,996470,568664,683107,654386,853349,158176,661506,997666,960961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002415s ]