SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002805s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494081 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494081 [ RunTime:0.003807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195105,960603,504123,506877,223423,756891,596086,474565,559679,298093,745606,326675,807700,65503,907905,718470,597497,928264,157194,236055,497831,206664,145559,958674,459375,162341,631909,937096,458632,998509,804511,152933,447753,914966,677807,82500,239379,493479,834334,268565,46641,180990,441429,425220,818583,711367,317791,374891,828882,379061,740666,41681,624698,523784,708673,661710,858828,645672,183841,255088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]