SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 593951 LIMIT 1 [ RunTime:0.000273s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593951 [ RunTime:0.001382s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610236,879644,462797,80124,101527,760783,107690,820178,893650,829251,162490,1004506,111231,14888,549481,837677,297860,1001458,800415,718857,1022411,628990,58566,886017,419859,542087,587,326082,272937,869275,774184,291959,331322,394069,453250,397672,679283,716168,113582,353909,169507,939087,202286,245560,797193,503590,856176,1024080,353949,513756,700108,48453,171414,881587,502633,838281,993001,772957,250426,794223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]