SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021613 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021613 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273448,181072,701830,51792,233555,1018851,808067,310334,934575,532598,568979,808078,622369,86772,417550,144346,778845,577518,164489,708982,676254,447827,78862,159936,821522,283095,625056,376268,794189,80364,47550,634034,911408,804096,876709,448147,669010,542659,524176,791934,607601,614702,984949,670982,335560,168430,588869,694575,213433,644199,454014,357007,908552,348032,291378,506423,285564,168143,697634,305975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]