SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589515 LIMIT 1 [ RunTime:0.001244s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589515 [ RunTime:0.003646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424650,486116,1021647,476033,521988,965004,295501,67325,370508,648756,63931,957584,844440,652550,513867,697797,134142,688734,165562,647631,675847,685348,168321,750339,931050,52373,977582,722078,448043,118587,451728,726792,250017,274167,579029,852012,223940,789958,744032,1009930,74128,1045854,599464,292327,130609,466091,866364,537977,134971,122238,63694,46278,149267,656821,965879,500890,772697,283995,940494,1000611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001815s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]