SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019599 LIMIT 1 [ RunTime:0.000545s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019599 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (386036,1017842,560574,579931,571434,541929,900425,88048,129263,427188,282362,1046064,334823,153071,864392,1017845,463853,410498,757497,141792,190094,446279,391969,29786,283116,760957,562053,682909,141904,164357,362478,43637,630418,919436,407040,725823,238751,949448,149787,574653,903014,167529,343363,612673,37092,431577,550654,55051,292736,240727,46941,531316,79974,842011,513800,531986,385211,492423,203289,15643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000845s ]