SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514236 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514236 [ RunTime:0.002910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644803,179921,671453,180939,736451,960672,970327,279517,946272,687450,302219,283437,13503,858094,103496,639179,567006,363466,394024,27528,311686,69692,417084,482094,889978,172779,396525,863565,163298,202175,860374,723614,952234,199733,606584,945574,157371,295914,861721,359943,180377,438764,504979,449110,940600,19643,233829,196262,43572,448788,47782,669590,556793,44651,663077,1032529,912978,748893,895207,694304) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]