SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003542s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035008 LIMIT 1 [ RunTime:0.001087s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035008 [ RunTime:0.005209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (976923,818041,106986,36732,94318,860285,5863,122049,897120,474496,346791,795008,293904,57261,362782,1001540,690989,251831,508549,229352,68195,295759,456187,1020919,491024,595873,219033,191358,320478,941631,126354,850765,923357,827010,916957,791664,62288,381159,266879,577612,197774,559326,1021801,778022,86482,35808,191319,884966,645896,635242,292457,586426,578016,231802,541130,923536,134038,1029336,288340,782264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003729s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000815s ]