SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201525 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201525 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (740127,868824,341764,672827,906525,290216,485165,442341,744912,859885,908228,228710,519560,652661,1000100,933497,166006,327932,723862,22722,160552,221602,558576,121375,11056,144166,372095,103217,317324,218499,743961,663968,295044,206803,192813,476809,1044950,337000,61959,589969,119567,336488,178829,804150,173617,365261,199518,130792,892907,143249,759330,829973,12175,970629,607057,918558,373362,731342,220832,186848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201525 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201525 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]