SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412334 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412334 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584997,309711,168248,352307,917518,479217,383609,1029849,545785,498158,932726,123110,459838,683972,346537,90260,746399,959851,493476,434108,187769,705857,983074,758678,775062,42037,1048070,656115,85452,541285,913884,666256,773727,997022,476106,240978,24222,30643,143700,826385,365811,163590,569638,944260,721013,229973,302853,624845,1021304,661869,920952,68614,173553,649534,855754,60857,534911,45205,345984,796646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412334 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412334 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001790s ]