SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580143 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580143 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701620,556025,600147,433623,358344,349692,900013,842836,1022702,665948,161164,245332,865548,587308,504969,192811,408354,922328,102331,613710,639571,143849,467104,178245,703130,956505,574720,109933,635294,556300,890974,656777,825407,680570,620590,11999,1010829,483283,760591,662879,710246,48201,779318,80462,354151,687552,881506,915195,501039,345536,658914,606805,390270,764507,519913,101018,140244,322560,497747,651884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]