SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341098 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341098 [ RunTime:0.002154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (386261,30618,737384,475334,329019,186244,132733,687681,406519,555301,860994,63200,407448,906946,788057,369876,379405,62910,415460,235814,405422,804773,1013496,349487,283962,891260,150375,95724,63503,329057,726765,838409,713560,15629,44324,62108,381774,893389,906544,759537,493011,400386,3004,931841,340713,480963,1030301,144293,450363,999703,586119,539818,906761,174904,657595,996416,725264,495927,586217,15179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]