SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029018 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029018 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812271,558235,844686,336758,279674,123006,48910,527756,448065,141268,570466,340327,685592,67616,553656,462938,717622,137072,24948,870630,877,566294,521661,862054,758175,19151,192943,323356,939671,604399,51667,101163,295935,735786,138060,247732,361743,937350,571279,296862,595917,261473,501399,893241,110648,215109,73512,718571,954232,202403,970524,202262,716741,833822,271368,222160,395645,321297,607156,975839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000708s ]