SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820010 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820010 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234497,770684,449408,340012,190532,649025,70316,750181,759321,302016,728284,1041377,282671,45853,438049,224544,777552,414276,812434,555489,199885,679505,867248,515207,161618,186644,718692,639865,447558,261503,416180,96638,136376,811474,1015100,81637,523077,1036968,50960,647417,119331,742509,727493,916369,685484,216541,858397,218064,524076,448554,616845,283696,669983,405170,635759,1014019,822740,491785,908709,491137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]