SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438450 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438450 [ RunTime:0.001434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902099,392086,752006,409262,252499,126651,622470,694186,211449,274584,230180,91181,679468,496329,963538,967183,397378,161600,122733,713076,552291,519675,794355,333764,914986,791493,410449,596050,437703,962252,571474,151319,817287,892988,315485,337638,109735,341800,665020,705783,224043,510669,430984,875170,280951,372039,37171,53556,865793,305202,1017238,684772,521596,266480,195845,407979,618405,537134,154078,397243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]