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` = 50642 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50642 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617124,728909,336265,42330,932390,271337,206397,772000,116619,265125,346660,749646,702555,269791,744022,950582,569098,507048,200872,195416,121291,687629,48554,213864,48269,898037,164067,440172,132176,123999,529341,764773,352012,491613,645371,622966,417245,951770,522785,830467,970690,211309,750564,356384,708454,240562,361793,811455,942527,88722,978829,531566,847370,717900,796017,90908,782394,938668,1022899,953524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50642 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50642 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]