SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290216 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290216 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874587,431221,429469,186167,174046,300488,616051,858690,274808,874229,523952,441919,339662,635173,6215,662693,924816,707926,884787,789797,357689,459568,368461,70171,629685,284482,247192,647444,862135,1043047,874787,866279,307550,172256,189786,23145,747169,8829,555424,575904,18407,342254,748118,725850,591494,147947,1021063,248969,597076,288008,407053,342800,430612,593108,202813,495664,624926,410818,1030404,693947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]