SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428879 LIMIT 1 [ RunTime:0.001391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428879 [ RunTime:0.011338s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447098,10367,601113,408515,576794,696970,876007,48025,838944,139918,944484,251856,1030159,15353,859830,341347,4892,578531,100565,463429,415847,902394,1001882,38247,686059,620713,822453,93994,774273,508050,89882,504079,676478,577243,808538,180001,133341,111564,63692,1001344,925352,488205,931814,731008,1029125,280707,1014201,870798,837570,1031276,108808,924863,189903,356519,110698,789516,219771,900058,699123,416587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428879 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428879 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]