SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435642 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435642 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201348,247735,328181,875937,294282,186692,1027676,1043757,745760,112462,219472,876823,790734,890351,975993,993699,147603,876968,512774,443116,546113,838614,405157,1048839,697945,147524,157300,894522,170248,1042021,888308,480477,787938,341911,53987,662222,539434,565682,716659,383538,685077,380859,898095,906231,686732,355259,740863,1010573,738496,98071,23317,31853,533536,1031695,911215,775829,819942,717198,619209,670919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435642 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435642 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]