SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432342 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432342 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112218,41950,606024,850058,996965,246383,126390,415653,857405,192042,99810,199959,101434,509303,983365,799054,865111,763045,568352,539235,87833,686828,596102,470685,88503,1048049,766482,55924,7603,928538,750105,63989,211404,619056,885454,694543,717592,647741,818363,458445,754012,753971,568831,116189,663195,924940,892249,856723,689068,22142,997345,609683,357604,950316,855587,993732,285951,888394,375873,888839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432342 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432342 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]