SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191090 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191090 [ RunTime:0.002310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530704,749747,852693,305004,323247,129139,629669,569032,584676,16765,420731,97799,31320,915433,218177,705076,337949,861811,668100,852660,200154,424852,21365,231296,190807,58728,288408,915441,247019,930287,771682,752872,412185,635767,546719,150291,905084,225057,507768,208889,172376,26692,515748,383106,261127,586671,583325,750619,906219,512255,6740,760583,175604,769752,572287,911520,875963,226161,263173,122827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]