SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019027 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019027 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279601,932164,938053,923198,818350,837897,791279,40150,584402,933524,685009,583719,36402,882728,257166,270352,288865,788708,1078,58094,553047,713543,420302,471863,172092,132518,687449,740997,537318,257350,364963,291707,617096,759366,260455,797858,214560,10070,424145,1007590,558881,829642,246960,780074,857345,161480,750012,1023259,202551,828432,783208,844186,833606,374616,402006,665010,560228,450355,299305,638357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]